Release 10.1A: OpenEdge Data Management:SQL Reference
UPDATE Syntax update statement ::= UPDATE table_name SET assignment [,assignment ], ... [ WHERE search_condition ] ; Assignment clause Syntax assignment ::= column = { expr | NULL } | ( column [, column ], ... ) = ( expr [, expr ], ... ) | ( column [, column ], ... ) = ( query_expression )
update statement ::= UPDATE table_name SET assignment [,assignment ], ... [ WHERE search_condition ] ;
update statement
::= UPDATE
table_name
SET
assignment
,
WHERE
search_condition
;
assignment ::= column = { expr | NULL } | ( column [, column ], ... ) = ( expr [, expr ], ... ) | ( column [, column ], ... ) = ( query_expression )